package com.settlement.system.model.entity.common;

import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.HeadFontStyle;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.alibaba.excel.annotation.write.style.HeadStyle;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.settlement.system.converter.DateFormatConvert;
import com.settlement.system.converter.FollowUpResponsibilityConvert;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;
/**
 * 订单稽核单据主表
 * @author Ximi
 * @since 2020-10-22
 */
@Data
@ExcelIgnoreUnannotated
@HeadStyle(fillBackgroundColor = 9,fillForegroundColor = 9)
@HeadRowHeight(value = 20)
@HeadFontStyle(fontHeightInPoints = 14)
public class TblOrderAuditBill extends BaseModel implements Serializable {

    /**
     * 订单稽核单据状态编码
     */
    @ApiModelProperty(value = "订单稽核单据状态编码")
    private String orderBillStatusNo;

    /**
     * 订单稽核单据状态名称
     */
    @ExcelProperty(value = "订单稽核单据状态名称")
    @ApiModelProperty(value = "订单稽核单据状态名称")
    private String orderBillStatusName;

    /**
     * 订单稽核主类别
     */
    @ExcelProperty(value = "订单稽核主类别")
    @ApiModelProperty(value = "订单稽核主类别")
    private String orderAuditMainName;

    /**
     * 订单稽核明细类别
     */
    @ExcelProperty(value = "订单稽核明细类别")
    @ApiModelProperty(value = "订单稽核明细类别")
    private String orderAuditDtlName;

    /**
     * 发退货时间
     */
    @ExcelProperty(value = "发退货时间", converter = DateFormatConvert.class)
    @ApiModelProperty(value = "发退货时间")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date outDate;

    /**
     * 下单时间
     */
    @ExcelProperty(value = "下单时间", converter = DateFormatConvert.class)
    @ApiModelProperty(value = "下单时间")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date orderDate;

    /**
     * 订单二级来源编码
     */
    @ExcelProperty(value = "订单二级来源编码")
    @ApiModelProperty(value = "订单二级来源编码")
    private String orderSourceNo;

    /**
     * 订单来源
     */
    @ExcelProperty(value = "订单来源")
    @ApiModelProperty(value = "订单来源")
    private String orderSource;

    /**
     * 订单三级来源编码
     */
    @ExcelProperty(value = "订单三级来源编码")
    @ApiModelProperty(value = "订单三级来源编码")
    private String threeLevelChannelNo;

    /**
     * 订单三级来源名称
     */
    @ExcelProperty(value = "订单三级来源名称")
    @ApiModelProperty(value = "订单三级来源名称")
    private String threeLevelChannelName;

    /**
     * 优购单号
     */
    @ExcelProperty(value = "优购主订单号")
    @ApiModelProperty(value = "优购主订单号")
    private String refBillNo;

    /**
     * 原始外部订单号
     */
    @ExcelProperty(value = "原始外部订单号")
    @ApiModelProperty(value = "原始外部订单号")
    private String spOrderNo;

    /**
     * po单号
     */
    @ExcelProperty(value = "po单号")
    @ApiModelProperty(value = "po单号")
    private String poNo;

    /**
     * 店铺编码
     */
    @ExcelProperty(value = "零售店铺编码")
    @ApiModelProperty(value = "零售店铺编码")
    private String shopNo;

    /**
     * 店铺全称
     */
    @ExcelProperty(value = "零售店铺名称")
    @ApiModelProperty(value = "零售店铺名称")
    private String shopName;

    /**
     * 渠道编码
     */
    @ExcelProperty(value = "渠道编码")
    @ApiModelProperty(value = "渠道编码")
    private String channelNo;

    /**
     * 渠道
     */
    @ExcelProperty(value = "渠道")
    @ApiModelProperty(value = "渠道")
    private String channelName;

    /**
     * 入账主体
     */
    @ExcelProperty(value = "账簿简称")
    @ApiModelProperty(value = "账簿简称")
    private String companySubject;

    /**
     * NC店铺编码
     */
    @ExcelProperty(value = "NC店铺编码")
    @ApiModelProperty(value = "NC店铺编码")
    private String ncShopNo;

    /**
     * NC店铺名称
     */
    @ExcelProperty(value = "NC店铺名称")
    @ApiModelProperty(value = "NC店铺名称")
    private String ncShopName;

    /**
     * 店铺账户
     */
    @ExcelProperty(value = "店铺账号")
    @ApiModelProperty(value = "店铺账号")
    private String shopAccount;

    /**
     * 发货数量
     */
    @ExcelProperty(value = "发货数量")
    @ApiModelProperty(value = "发货数量")
    private Integer sendQty;

    /**
     * 发货金额
     */
    @ExcelProperty(value = "发货金额")
    @ApiModelProperty(value = "发货金额")
    private BigDecimal sendAmount;

    /**
     * 退货数量
     */
    @ExcelProperty(value = "退货数量")
    @ApiModelProperty(value = "退货数量")
    private Integer returnQty;

    /**
     * 退货金额
     */
    @ExcelProperty(value = "退货金额")
    @ApiModelProperty(value = "退货金额")
    private BigDecimal returnAmount;

    /**
     * 收款日期
     */
    @ExcelProperty(value = "收款日期", converter = DateFormatConvert.class)
    @ApiModelProperty(value = "收款日期")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date receiveDate;

    /**
     * 收款金额
     */
    @ExcelProperty(value = "收款金额")
    @ApiModelProperty(value = "收款金额")
    private BigDecimal receiveAmount;

    /**
     * 退款日期
     */
    @ExcelProperty(value = "退款日期", converter = DateFormatConvert.class)
    @ApiModelProperty(value = "退款日期")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date refundDate;

    /**
     * 退款金额
     */
    @ExcelProperty(value = "退款金额")
    @ApiModelProperty(value = "退款金额")
    private BigDecimal refundAmount;

    /**
     * 保证金退款金额
     */
    @ExcelProperty(value = "保证金退款金额")
    @ApiModelProperty(value = "保证金退款金额")
    private BigDecimal depositRefundAmount;

    /**
     * 系统调账日期
     */
    @ExcelProperty(value = "系统调账日期")
    @ApiModelProperty(value = "系统调账日期")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date sysAdjustDate;

    /**
     * 系统调账数量
     */
    @ExcelProperty(value = "系统调账数量")
    @ApiModelProperty(value = "系统调账数量")
    private Integer sysAdjustQty;

    /**
     * 系统调整金额
     */
    @ExcelProperty(value = "系统调整金额")
    @ApiModelProperty(value = "系统调整金额")
    private BigDecimal sysAdjustAmount;

    /**
     * 财务调账日期
     */
    @ExcelProperty(value = "财务调账日期")
    @ApiModelProperty(value = "财务调账日期")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date finAdjustDate;

    /**
     * 财务调整金额
     */
    @ExcelProperty(value = "财务调整金额")
    @ApiModelProperty(value = "财务调整金额")
    private BigDecimal finAdjustAmount;

    /**
     * 差异数量
     */
    @ExcelProperty(value = "差异数量")
    @ApiModelProperty(value = "差异数量")
    private Integer diffQty;

    /**
     * 应收账款余额
     */
    @ExcelProperty(value = "应收账款余额")
    @ApiModelProperty(value = "应收账款余额")
    private BigDecimal receivableAmount;

    /**
     * 业务日期
     */
    @ExcelProperty(value = "业务日期",converter = DateFormatConvert.class)
    @ApiModelProperty(value = "业务日期")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date businessDate;

    /**
     * 异常售后未提报金额
     */
    @ExcelProperty(value = "异常售后未提报金额")
    @ApiModelProperty(value = "异常售后未提报金额")
    private BigDecimal diffAbnormalAmount;

    /**
     * 提报部门
     * "020客服","O2O_CUSTOMER_SERVICE
     * 物流部","LOGISTICS_DEPT
     * 电商客服","E_COMMERCE_CUSTOMER_SERVICE
     * 品牌客服","BRAND_CUSTOMER_SERVICE
     * 售后","1"
     * 物流","2"
     * "商家","3
     * 地区","4
     * 集团物流","5
     * 电商客服","6
     * 集团客服","7
     */
    @ExcelProperty(value = "提报部门",converter = FollowUpResponsibilityConvert.class)
    @ApiModelProperty(value = "提报部门")
    private String followUpResponsibility;

    /**
     * 单据编码
     */
    @ExcelProperty(value = "单据编码")
    @ApiModelProperty(value = "单据编码")
    private String billNo;

    /**
     * 责任方编码
     */
    @ExcelProperty(value = "责任方编码")
    @ApiModelProperty(value = "责任方编码")
    private String responsibleNo;

    /**
     * 责任方
     */
    @ExcelProperty(value = "责任方")
    @ApiModelProperty(value = "责任方")
    private String responsibleName;

    /**
     * 损失原因编码
     */
    @ExcelProperty(value = "损失原因编码")
    @ApiModelProperty(value = "损失原因编码")
    private String lossReasonNo;

    /**
     * 损失原因
     */
    @ExcelProperty(value = "损失原因")
    @ApiModelProperty(value = "损失原因")
    private String lossReasonName;

    /**
     * 损失原因细则编码
     */
    @ExcelProperty(value = "损失原因细则编码")
    @ApiModelProperty(value = "损失原因细则编码")
    private String lossReasonDtlNo;

    /**
     * 损失原因细则名称
     */
    @ExcelProperty(value = "损失原因细则名称")
    @ApiModelProperty(value = "损失原因细则名称")
    private String lossReasonDtlName;

    /**
     * 客服初步核实人
     */
    @ExcelProperty(value = "初步核实人")
    @ApiModelProperty(value = "初步核实人")
    private String firstServicePerson;

    /**
     * 客服初步核实人名称
     */
    @ExcelProperty(value = "初步核实人名称")
    @ApiModelProperty(value = "初步核实人名称")
    private String firstServicePersonName;

    /**
     * 责任部门跟进结果
     */
    @ExcelProperty(value = "责任部门跟进结果")
    @ApiModelProperty(value = "责任部门跟进结果")
    private String responsibleResults;

    /**
     * 是否确认损失(0不确认 1确认)
     */
    @ExcelProperty(value = "是否确认损失(0不确认 1确认)")
    @ApiModelProperty(value = "是否确认损失(0不确认 1确认)")
    private Integer isLoss;

    /**
     * 责任部门核实人
     */
    @ExcelProperty(value = "责任部门核实人")
    @ApiModelProperty(value = "责任部门核实人")
    private String responsiblePerson;

    /**
     * 备注
     */
    @ExcelProperty(value = "备注")
    @ApiModelProperty(value = "备注")
    private String remark;

    /**
     * 质检时间
     */
    @ExcelProperty(value = "质检时间")
    @ApiModelProperty(value = "质检时间")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date qualityDate;

    /**
     * 质检优购子订单号
     */
    @ExcelProperty(value = "质检优购子订单号")
    @ApiModelProperty(value = "质检优购子订单号")
    private String qualityBillNo;

    /**
     * 质检数量
     */
    @ExcelProperty(value = "质检数量")
    @ApiModelProperty(value = "质检数量")
    private Integer qualityQty;

    /**
     * 质检月份/收款月份
     */
    @ExcelProperty(value = "质检月份/收款月份")
    @ApiModelProperty(value = "质检月份/收款月份")
    private String deductionMonth;

    /**
     * 打款时间
     */
    @ExcelProperty(value = "打款时间")
    @ApiModelProperty(value = "打款时间")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date paymentTime;

    /**
     * 收款交易号
     */
    @ExcelProperty(value = "收款交易号")
    @ApiModelProperty(value = "收款交易号")
    private String collectionTransactionNo;

    /**
     * 收款金额
     */
    @ExcelProperty(value = "追回款项金额")
    @ApiModelProperty(value = "追回款项金额")
    private BigDecimal receivingAmount;

    /**
     * 盘盈单号
     */
    @ExcelProperty(value = "盘盈单号")
    @ApiModelProperty(value = "盘盈单号")
    private String inventoryBillNo;

    /**
     * 待处理明细ID
     */
    @ApiModelProperty(value = "待处理明细ID")
    private String dealDtlId;

    /**
     * 创建人
     */
    @ApiModelProperty(hidden = true)
    @ExcelProperty(value = "创建人")
    public String createUser;

    /**
     * 创建时间
     */
    @ApiModelProperty(hidden = true)
    @ExcelProperty(value = "创建日期")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    public Date createTime;

    /**
     * 更新人
     */
    @ApiModelProperty(hidden = true)
    @ExcelProperty(value = "修改人")
    public String updateUser;

    /**
     * 更新时间
     */
    @ApiModelProperty(hidden = true)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @ExcelProperty(value = "修改时间")
    public Date updateTime;
}
